---
title: PivotField.MemberPropertyCaption Property (Excel)
keywords: vbaxl10.chm240140
f1_keywords:
- vbaxl10.chm240140
ms.prod: excel
api_name:
- Excel.PivotField.MemberPropertyCaption
ms.assetid: 66f2ad5f-cd37-74ef-e9df-cd4793212026
ms.date: 06/08/2017
---


# PivotField.MemberPropertyCaption Property (Excel)

Setting the  **MemberPropertyCaption** property controls which member property is used as caption for a given level. Read/write **Boolean** .


## Syntax

 _expression_ . **MemberPropertyCaption**

 _expression_ A variable that represents a **PivotField** object.


## Remarks


 **Note**  This setting has a visual effect only when  **UseMemberPropertyAsCaption** is set to **True** for the PivotField.

When  **MemberPropertyCaption** is set, the setting is remembered while toggling the **[UseMemberPropertyAsCaption](pivotfield-usememberpropertyascaption-property-excel.md)** property.


## See also


#### Concepts


[PivotField Object](pivotfield-object-excel.md)

